# | DATABASE,C,12 | INDEX,C,12 | KEY_FIELD,C,80 | DESCRIP,C,40 | PACK,C,1 | REINDEX,C,1
|
---|
1 | FUNCKEYS | FUNCKEYS | FUNC_KEY | FUNCTION KEY ASSIGNMENTS | | |
2 | USERS | USERS1 | UPPER(LOCATION) | | | |
3 | USERS | USERS2 | DESCRIP | | | |
4 | HELP | HELP | FIELD_DB+FIELD_NAME | DATABASE + FIELDNAME | | |
5 | CLIENTS | CLIENTS1 | CLIENT | CLIENT NUMBER | | |
6 | CLIENTS | CLIENTS2 | UPPER(LEFT(TRIM(LNAME)+TRIM(FNAME)+COMPANY,40)) | LAST+FIRST+COMPANY | | |
7 | CLIENTS | CLIENTS3 | UPPE(LEFT(TRIM(COMPANY)+TRIM(STATE+CITY)+LNAME+SPAC(40),40)) | COMPANY | | |
8 | PROJECT | PROJECT1 | PROJECT | PROJECT | | |
9 | PROJECT | PROJECT2 | DESCRIP | DESCRIPTION | | |
10 | OBJECTIV | OBJECT1 | PROJECT+PROGRAM | PROJECT | | |
11 | OBJECTIV | OBJECT2 | DESCRIP | DESCRIP | | |
12 | EVENTS | EVENTS1 | PROJECT+PROGRAM+DTOS(DATEIN) | PROJECT | | |
13 | EVENTS | EVENTS2 | INV_NUM+IIF(CLIENT#"SHAR",PROJECT+PROGRAM+DTOS(DATEIN),SPACE(20)) | | | |
14 | DETAILS | DETAILS2 | PROJECT+PROGRAM+DTOS(DATEIN+7*VAL(PRIORITY)) | | | |
15 | DETAILS | DETAILS1 | DONEBY+DTOS(DATEIN+7*VAL(PRIORITY))+PROJECT | | | |
16 | DETAILS | DETAILS3 | DTOS(DATEIN+7*VAL(PRIORITY)) | | | |
17 | DISKETTE | DISKETTE | SERIAL | | | |
18 | ACCOUNTS | ACCOUNT1 | ACCOUNT_ID | ACCOUNT NUMBER | | |
19 | ACCOUNTS | ACCOUNT2 | DESCRIP | DESCRIPTIVE | | |
20 | ACCTDESC | ACCTDES1 | ACCOUNT_ID | "1,2,3,4 OR 5" | | |
21 | ACCTDESC | ACCTDES2 | DESCRIP | DESCRIPTIVE | | |
22 | LEDGER | LEDGER | ACCOUNT_ID+DTOS(DATE) | GENERAL LEDGER | | |
23 | DEPT | DEPT1 | DEPT | DEPARTMENT CODE | | |
24 | DEPT | DEPT2 | DESCRIP | DESCRIPTIVE | | |
25 | JOURNAL | JOURNAL | STR(TRANS,4) | | | |
26 | EMPLOYEE | EMPLOY1 | DONEBY | | | |
27 | PRINTERS | PRINTER1 | STR(RECNO(),2) | PRINTER ID NO. | | |
28 | PRINTERS | PRINTER2 | UPPER(DESCRIP) | PRINTER DESCRIPTION | | |
29 | EVENTS | EVENTS3 | BATCH | BATCH NUMBER | | |
30 | EMPLOYEE | EMPLOY2 | NAME | | | |
31 | INVOICE | INVOICE1 | INVOICE | | | |
32 | INVOICE | INVOICE2 | CLIENT+DESCEND(INVOICE) | | | |
33 | INVOICE | INVOICE3 | PROJECT+INVOICE | | | |
34 | PROGRAMS | PROGRAM1 | PROJECT | | | |
35 | PROGRAMS | PROGRAM2 | DESCRIP | | | |
36 | PROGRAMS | PROGRAM3 | TIER+PROJECT | | | |
37 | ERRTRACK | ERROR1 | SERIAL_NUM+DESCEND(DTOS(ENTERED)) | | | |
38 | QUESTION | QUEST1 | PROJECT+UPPER(LEFT(DESCRIP,10)) | | | |
39 | CONTACTS | CONTACT1 | CLIENT+DESCEND(DTOS(DATE))+DESCEND(CTIME) | | | |
40 | CLIENTS | CLIENTS4 | LEFT(CLIENT,4)+STR(10000-VAL(SUBSTR(CLIENT,5,4))) | INVERSE SORT | | |
41 | SUPPORT | SUPPORT1 | SERIAL_NUM | | | |
42 | SUPPORT | SUPPORT2 | CLIENT+SUBSTR(SERIAL_NUM,5,1)+SERIAL_NUM | | | |
43 | SUPPORT | SUPPORT3 | PROJECT+CLIENT | | | |
44 | CLIENTS | CLIENTS5 | SALES_REP+DTOS(DATE)+TIME | NEXT CONTACT | | |
45 | CONTACTS | CONTACT2 | PROJECT+DTOS(DATE) | | | |
46 | QUESTION | QUEST2 | PROJECT+UPPER(KEYWORD) | | | |
47 | ERRTRACK | ERROR2 | CLIENT+DESCEND(DTOC(ENTERED)) | | | |
48 | ERRTRACK | ERROR3 | PROJECT | | | |
49 | SUPPORT | SUPPORT4 | LEFT(SERIAL_NUM,5)+STR(10000-VAL(SUBS(SERIAL_NUM,6,4))) | INVERSE SORT | | |
50 | CLIENTS | CLIENTS6 | STATE+UPPER(CITY)+UPPER(LEFT(COMPANY,20))+UPPER(LNAME) | STATE+CITY+COMPANY | | |
51 | CLIENTS | CLIENTS7 | SALES_REP+LEFT(CLIENT,4)+DTOS(DATE)+TIME | NEXT PROJECT | | |
52 | POSTAGE | POSTAGE1 | PROJECT+DEPT | PROJECT CODE+COST CENTER | | |
53 | POSTAGE | POSTAGE2 | DTOS(DATE) | DATE | | |
54 | INVENTOR | INVENT1 | STOCK_NUM | STOCK NUMBER | | |
55 | INVENTOR | INVENT2 | DESCRIP | DESCRIPTION | | |
56 | STATE | STATE1 | ST_AB | STATE ABBREVIATION | | |
57 | STATE | STATE2 | ST_NAME | STATE NAME | | |
58 | SOURCES | SOURCES | STOCK_NUM | STOCK NUMBER | | |
59 | RELEASE | RELEASE1 | CODE | | | |
60 | RELEASE | RELEASE2 | DESCRIP | | | |
61 | CONTACTS | CONTACT3 | DONEBY+DESCEND(DTOS(DATE)) | | | |
62 | ERRTRACK | ERROR5 | KEYWORDS | | | |
63 | ERRTRACK | ERROR4 | DESCRIP | | | |
64 | LEASE | LEASE | CLIENT | LEASE | | |
65 | CLIENTS | CLIENTS8 | ZIP | | | |
66 | COMPANY | COMPANY1 | COMPNO | | | |
67 | COMPANY | COMPANY2 | UPPER(COMPANY) | | | |
68 | COMPANY | COMPANY3 | UPPER(STATE+CITY+COMPANY) | | | |
69 | COMPANY | COMPANY4 | ZIP | | | |
70 | COMPANY | COMPANY5 | LEFT(COMPNO,4)+STR(10000-VAL(SUBS(COMPNO,5,4))) | | | |
71 | FILTER | FILTER1 | FILE_NAME+FILT_CODE | | | |
72 | FILTER | FILTER2 | FILE_NAME+UPPER(DESCRIP) | | | |
73 | UPS | UPS1 | CLIENT | | | |
74 | UPS | UPS2 | UPPER(LNAME) | | | |
75 | UPS | UPS3 | UPPER(COMPANY) | | | |
76 | EMPLOYEE | EMPLOY3 | SSN | SSN | | |
77 | EMPLOYEE | EMPLOY4 | UPPER(LNAME+FNAME) | NAME | | |
78 | PRCLIENT | PRCLIEN1 | CLNO | CLIENT NUMBER | | |
79 | PRCLIENT | PRCLIEN2 | UPPER(CLIENT) | CLIENT NAME | | |
80 | PAYROLL | PAYROLL1 | SSN+DTOS(PAY_DATE) | SSN + PAY DATE | | |
81 | PAYROLL | PAYROLL2 | DTOS(PAY_DATE)+SSN | PAY DATE + SSN | | |
82 | PAYROLL | PAYROLL3 | CKNO | CKNO | | |
83 | TAXSCHD | TAXSCHD | TAX_AUTH+FIL_STAT | | | |
84 | HISTORY | HISTORY1 | SSN +DTOS(PAY_DATE) | SSN + PAY_DATE | | |
85 | HISTORY | HISTORY2 | DTOS(PAY_DATE)+SSN | PAY_DATE + SSN | | |
86 | HISTORY | HISTORY3 | CKNO | CKNO | | |
87 | W2YEAR | W2YEAR1 | SSN | SSN | | |
88 | INFOREQ | INFOREQ | CLIENT | | |
|